/**
 * 
 */
package com.orange.handler;

import java.sql.SQLException;
import java.util.Map;

import com.orange.dbhelp.page.Page;
import com.orange.modules.entity.expert.AuthQuestionnaire;
import com.orange.modules.entity.expert.AuthSchoolQuestionnaire;

/**
 * @author gaogs
 *
 * 2016-10-16
 */
public interface AuthQuestionnaireService {
	
	/**
	 * 根据账号查询问卷调查表
	 * @param pid
	 * @return
	 * @throws SQLException
	 */
	public AuthQuestionnaire queryAuthQuestionnaireInfoBypid(String pid) throws SQLException ;
	
	public AuthSchoolQuestionnaire AuthSchoolQuestionnaire(String schoolId) throws SQLException ;
	
	/**
	 * 给问卷调查表插入及保存数据
	 * @param aq
	 * @throws SQLException
	 */
	public void updateAuthSchoolInfo(AuthQuestionnaire aq) throws SQLException;
	
	/**
	 * 分页显示调查数据表
	 * @param map
	 * @return
	 * @throws SQLException
	 */
	public Page<AuthSchoolQuestionnaire> queryAuthQuestionnairePage(Map<String, String> map) throws SQLException;

	/**
	 * 根据学校id查询问卷调查
	 */
	public AuthSchoolQuestionnaire queryAuthSchoolQuestionnaireBySchoolId(String schoolId) throws SQLException;
}
